﻿BEGIN TRAN

USE [Product]  /* change to your project DB */

GO
/****** Object:  Table [dbo].[ServicesTranslator] ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ServicesTranslator](
	[TranslatorId] [smallint] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
	[KeyColumn] [varchar](300) NOT NULL,
	[Area] [nvarchar](150) NOT NULL,
 CONSTRAINT [PK_ServicesTranslator] PRIMARY KEY CLUSTERED 
(
	[TranslatorId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ServicesLanguage]  ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ServicesLanguage](
    [LanguageId] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
    [LanguageName] [varchar](10) NOT NULL,
    [ShowFlag] [bit] NOT NULL,
 CONSTRAINT [PK_ServicesLanguage] PRIMARY KEY CLUSTERED 
(
	[LanguageId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ServicesTranslations] ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ServicesTranslations](
	[TranslationsId] [smallint] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
	[TranslatorId] [smallint] NOT NULL,
	[LanguageName] [varchar](10) NOT NULL,
	[Translation] [nvarchar](2000) NOT NULL,
 CONSTRAINT [PK_ServicesTranslations] PRIMARY KEY NONCLUSTERED 
(
	[TranslationsId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX [IX_ServicesTranslations] ON [dbo].[ServicesTranslations] 
(
	[TranslatorId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  ForeignKey [FK_ServicesTranslations_ServicesTranslator]    ******/
ALTER TABLE [dbo].[ServicesTranslations]  WITH CHECK ADD  CONSTRAINT [FK_ServicesTranslations_ServicesTranslator] FOREIGN KEY([TranslatorId])
REFERENCES [dbo].[ServicesTranslator] ([TranslatorId])
GO
ALTER TABLE [dbo].[ServicesTranslations] CHECK CONSTRAINT [FK_ServicesTranslations_ServicesTranslator]
GO

--ROLLBACK TRAN
COMMIT TRAN